package jpa.entitys.synchro.staging;

import java.io.Serializable;
import java.math.BigDecimal;

import javax.persistence.*;

import java.util.Date;


/**
 * The persistent class for the MM_LIVCONTRACTOR_DEDUCT database table.
 * 
 */
@Entity
@Table(name="MM_LIVCONTRACTOR_DEDUCT")
@NamedQueries({
    @NamedQuery(name = "MmLivcontractorDeduct.findAll", query = " SELECT c FROM MmLivcontractorDeduct c"),
    @NamedQuery(name = "MmLivcontractorDeduct.findById", query = " SELECT c FROM MmLivcontractorDeduct c WHERE c.promisStagingId = :Id"),
    @NamedQuery(name = "MmLivcontractorDeduct.findByInstanceNo", query = " SELECT c FROM MmLivcontractorDeduct c WHERE c.instanceNo = :instanceNo order by c.company,c.project,c.mainContractDocNo,c.status,c.seq asc"),
    @NamedQuery(name = "MmLivcontractorDeduct.findAllIsSync", query = " SELECT c FROM MmLivcontractorDeduct c WHERE c.issync = :issync order by c.instanceNo asc"),
    })
public class MmLivcontractorDeduct extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID")
	private String promisStagingId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ACTION_HANDLER")
	private String actionHandler;

	@Column(name="BUILDING_PHASE")
	private String buildingPhase;

	private String company;

	@Column(name="CONTRACT_DOC_NO")
	private String contractDocNo;

	@Column(name="CONTRACT_NO")
	private String contractNo;

	@Column(name="CONTRACTOR_CODE")
	private String contractorCode;

	@Column(name="CONTRACTOR_NAME")
	private String contractorName;

	@Column(name="COST_CONTRACT_DEDUCT_PO_ID")
	private String costContractDeductPoId;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Column(name="CREATED_ON")
	private String createdOn;

	@Column(name="DEDUCT_AMOUNT")
	private String deductAmount;

	@Column(name="DEDUCT_FLAG")
	private String deductFlag;

	@Column(name="DEDUCT_NET_AMOUNT")
	private String deductNetAmount;

	@Column(name="DOC_NO")
	private String docNo;

	@Column(name="EXT_REF_KEY")
	private String extRefKey;

	@Column(name="EXT_REF_NO")
	private String extRefNo;

	@Column(name="FEE_AMOUNT")
	private String feeAmount;

	@Column(name="FEE_RATE")
	private String feeRate;

	@Column(name="INSTANCE_NO")
	private String instanceNo;

	@Column(name="INTERFACE_NO")
	private String interfaceNo;

	private String isactive;

	private String issync;

	@Column(name="MAIN_CONTRACT_DOC_NO")
	private String mainContractDocNo;

	@Column(name="MAIN_CONTRACT_NO")
	private String mainContractNo;

	@Column(name="MSG_ACT_RESULT")
	private String msgActResult;

	@Column(name="MSG_ALT_DESC")
	private String msgAltDesc;

	@Column(name="MSG_CODE")
	private String msgCode;

	@Column(name="MSG_DESC")
	private String msgDesc;

	@Column(name="PAY_DEDUCT")
	private String payDeduct;

	@Column(name="PAY_FEE")
	private String payFee;

	@Column(name="PAY_NET_DEDUCT")
	private String payNetDeduct;

	private String project;

	@Column(name="PROPERTY_CATEGORY")
	private String propertyCategory;

	@Column(name="REF_INSTALLMENT_NO")
	private String refInstallmentNo;

	@Column(name="REF_SYNC_PK_ID")
	private String refSyncPkId;

	@Column(name="REQUEST_NO")
	private String requestNo;

	@Column(name="SAP_COMPANY_CODE")
	private String sapCompanyCode;

	@Column(name="SAP_PLANT_CODE")
	private String sapPlantCode;

	private BigDecimal seq;

	private String status;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="UNIT_NUMBER")
	private String unitNumber;

	@Column(name="UPDATED_BY")
	private String updatedBy;

	@Column(name="UPDATED_ON")
	private String updatedOn;

	@Column(name="ZONE_CODE")
	private String zoneCode;
	
	@Column(name="CONT_UNIT_SEQ ")
	private String contUnitSeq;	
	
	@Column(name="INSTALLMENT_NUMBER_STR ")
	private String installmentNumberStr;	

	public MmLivcontractorDeduct() {
	} 
	
	/**
	 * @return the contUnitSeq
	 */
	public String getContUnitSeq() {
		return contUnitSeq;
	}



	/**
	 * @param contUnitSeq the contUnitSeq to set
	 */
	public void setContUnitSeq(String contUnitSeq) {
		this.contUnitSeq = contUnitSeq;
	}



	/**
	 * @return the installmentNumberStr
	 */
	public String getInstallmentNumberStr() {
		return installmentNumberStr;
	}



	/**
	 * @param installmentNumberStr the installmentNumberStr to set
	 */
	public void setInstallmentNumberStr(String installmentNumberStr) {
		this.installmentNumberStr = installmentNumberStr;
	}



	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
	}

	public String getActionHandler() {
		return this.actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getBuildingPhase() {
		return this.buildingPhase;
	}

	public void setBuildingPhase(String buildingPhase) {
		this.buildingPhase = buildingPhase;
	}

	public String getCompany() {
		return this.company;
	}

	public void setCompany(String company) {
		this.company = company;
	}

	public String getContractDocNo() {
		return this.contractDocNo;
	}

	public void setContractDocNo(String contractDocNo) {
		this.contractDocNo = contractDocNo;
	}

	public String getContractNo() {
		return this.contractNo;
	}

	public void setContractNo(String contractNo) {
		this.contractNo = contractNo;
	}

	public String getContractorCode() {
		return this.contractorCode;
	}

	public void setContractorCode(String contractorCode) {
		this.contractorCode = contractorCode;
	}

	public String getContractorName() {
		return this.contractorName;
	}

	public void setContractorName(String contractorName) {
		this.contractorName = contractorName;
	}

	public String getCostContractDeductPoId() {
		return this.costContractDeductPoId;
	}

	public void setCostContractDeductPoId(String costContractDeductPoId) {
		this.costContractDeductPoId = costContractDeductPoId;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getDeductAmount() {
		return this.deductAmount;
	}

	public void setDeductAmount(String deductAmount) {
		this.deductAmount = deductAmount;
	}

	public String getDeductFlag() {
		return this.deductFlag;
	}

	public void setDeductFlag(String deductFlag) {
		this.deductFlag = deductFlag;
	}

	public String getDeductNetAmount() {
		return this.deductNetAmount;
	}

	public void setDeductNetAmount(String deductNetAmount) {
		this.deductNetAmount = deductNetAmount;
	}

	public String getDocNo() {
		return this.docNo;
	}

	public void setDocNo(String docNo) {
		this.docNo = docNo;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getFeeAmount() {
		return this.feeAmount;
	}

	public void setFeeAmount(String feeAmount) {
		this.feeAmount = feeAmount;
	}

	public String getFeeRate() {
		return this.feeRate;
	}

	public void setFeeRate(String feeRate) {
		this.feeRate = feeRate;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getInterfaceNo() {
		return this.interfaceNo;
	}

	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getMainContractDocNo() {
		return this.mainContractDocNo;
	}

	public void setMainContractDocNo(String mainContractDocNo) {
		this.mainContractDocNo = mainContractDocNo;
	}

	public String getMainContractNo() {
		return this.mainContractNo;
	}

	public void setMainContractNo(String mainContractNo) {
		this.mainContractNo = mainContractNo;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getPayDeduct() {
		return this.payDeduct;
	}

	public void setPayDeduct(String payDeduct) {
		this.payDeduct = payDeduct;
	}

	public String getPayFee() {
		return this.payFee;
	}

	public void setPayFee(String payFee) {
		this.payFee = payFee;
	}

	public String getPayNetDeduct() {
		return this.payNetDeduct;
	}

	public void setPayNetDeduct(String payNetDeduct) {
		this.payNetDeduct = payNetDeduct;
	}

	public String getProject() {
		return this.project;
	}

	public void setProject(String project) {
		this.project = project;
	}

	public String getPropertyCategory() {
		return this.propertyCategory;
	}

	public void setPropertyCategory(String propertyCategory) {
		this.propertyCategory = propertyCategory;
	}

	public String getRefInstallmentNo() {
		return this.refInstallmentNo;
	}

	public void setRefInstallmentNo(String refInstallmentNo) {
		this.refInstallmentNo = refInstallmentNo;
	}

	public String getRefSyncPkId() {
		return this.refSyncPkId;
	}

	public void setRefSyncPkId(String refSyncPkId) {
		this.refSyncPkId = refSyncPkId;
	}

	public String getRequestNo() {
		return this.requestNo;
	}

	public void setRequestNo(String requestNo) {
		this.requestNo = requestNo;
	}

	public String getSapCompanyCode() {
		return this.sapCompanyCode;
	}

	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public String getSapPlantCode() {
		return this.sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public BigDecimal getSeq() {
		return this.seq;
	}

	public void setSeq(BigDecimal seq) {
		this.seq = seq;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

	public String getZoneCode() {
		return this.zoneCode;
	}

	public void setZoneCode(String zoneCode) {
		this.zoneCode = zoneCode;
	}

}